home *** CD-ROM | disk | FTP | other *** search
/ comtecelectrical.ca / www.comtecelectrical.ca.tar / www.comtecelectrical.ca / infobots / Backup / MSOCache / All Users / 90000409-6000-11D3-8CFE-0150048383C9 / M4561414.CAB / XLQTOC.XML_1033 < prev    next >
Extensible Markup Language  |  2003-03-07  |  26KB  |  336 lines
  1.  ■<?xml version="1.0" encoding="utf-16"?>
  2. <toc>
  3.     <book>
  4.         <label>Microsoft Query Help</label>
  5.         <book>
  6.             <label>Getting Started</label>
  7.             <topic>
  8.                 <label>About using Microsoft Query to retrieve external data</label>
  9.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowThumbAboutQuery.htm</url>
  10.             </topic>
  11.         </book>
  12.         <book>
  13.             <label>Getting Help</label>
  14.             <topic>
  15.                 <label>Get program information about Microsoft Query</label>
  16.                 <url>mk:@MSITStore:msqry32.chm::/html/ofhowGetInformationAboutMyComputer.htm</url>
  17.             </topic>
  18.         </book>
  19.         <book>
  20.             <label>Keyboard Shortcuts</label>
  21.             <topic>
  22.                 <label>Use keyboard shortcuts in Microsoft Query</label>
  23.                 <url>mk:@MSITStore:msqry32.chm::/html/qukbdUseKeyboardShortcutKeys.htm</url>
  24.             </topic>
  25.             <topic>
  26.                 <label>Move in the Microsoft Query panes by using shortcut keys</label>
  27.                 <url>mk:@MSITStore:msqry32.chm::/html/qukbdMoveInMicrosoftQueryPanesByUsingShortcutKeys.htm</url>
  28.             </topic>
  29.             <topic>
  30.                 <label>Select data and criteria by using shortcut keys</label>
  31.                 <url>mk:@MSITStore:msqry32.chm::/html/qukbdSelectDataCriteriaByUsingShortcutKeys.htm</url>
  32.             </topic>
  33.             <topic>
  34.                 <label>Edit data and criteria by using shortcut keys</label>
  35.                 <url>mk:@MSITStore:msqry32.chm::/html/qukbdEditDataCriteriaByUsingShortcutKeys.htm</url>
  36.             </topic>
  37.             <topic>
  38.                 <label>Function keys in Microsoft Query</label>
  39.                 <url>mk:@MSITStore:msqry32.chm::/html/qukbdFunctionKeysInMicrosoftQuery.htm</url>
  40.             </topic>
  41.             <topic>
  42.                 <label>Use shortcut keys in the OLAP Cube Wizard</label>
  43.                 <url>mk:@MSITStore:msqry32.chm::/html/qurefOLAPWizKeys.htm</url>
  44.             </topic>
  45.         </book>
  46.         <book>
  47.             <label>Installation and data sources</label>
  48.             <topic>
  49.                 <label>Install an ODBC driver so that you can access an external data source</label>
  50.                 <url>mk:@MSITStore:msqry32.chm::/html/quconInstallODBCDriverSoThatYouCanAccessExternalDataSource.htm</url>
  51.             </topic>
  52.             <topic>
  53.                 <label>Install OLAP providers</label>
  54.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowInstallOLAP.htm</url>
  55.             </topic>
  56.         </book>
  57.         <book>
  58.             <label>Setting Up Data Sources</label>
  59.             <topic>
  60.                 <label>Databases you can access</label>
  61.                 <url>mk:@MSITStore:msqry32.chm::/html/qurefDatabasesYouCanAccessWithMicrosoftQuery.htm</url>
  62.             </topic>
  63.             <topic>
  64.                 <label>Specify a source to retrieve data from</label>
  65.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowSpecifySourceToRetrieveDataFrom.htm</url>
  66.             </topic>
  67.             <topic>
  68.                 <label>Set up a data source that uses the Microsoft Access driver</label>
  69.                 <url>mk:@MSITStore:msqry32.chm::/html/qutbcMicrosoftAccessDriver.htm</url>
  70.             </topic>
  71.             <topic>
  72.                 <label>Set up a data source that uses the Microsoft dBASE or FoxPro driver</label>
  73.                 <url>mk:@MSITStore:msqry32.chm::/html/qutbcMicrosoftDBaseDriver.htm</url>
  74.             </topic>
  75.             <topic>
  76.                 <label>Set up a data source that uses the Microsoft Excel driver</label>
  77.                 <url>mk:@MSITStore:msqry32.chm::/html/qutbcMicrosoftExcelDriver.htm</url>
  78.             </topic>
  79.             <topic>
  80.                 <label>Set up a data source that uses the Microsoft ODBC for Oracle driver</label>
  81.                 <url>mk:@MSITStore:msqry32.chm::/html/qutbcrOracleDriver.htm</url>
  82.             </topic>
  83.             <topic>
  84.                 <label>Set up a data source that uses the Microsoft Paradox driver</label>
  85.                 <url>mk:@MSITStore:msqry32.chm::/html/qutbcMicrosoftFoxProDriver.htm</url>
  86.             </topic>
  87.             <topic>
  88.                 <label>Set up a data source that uses the Microsoft SQL Server OLAP Services driver</label>
  89.                 <url>mk:@MSITStore:msqry32.chm::/html/qutbcMolapDriver.htm</url>
  90.             </topic>
  91.             <topic>
  92.                 <label>Set up a data source that uses the Microsoft text driver</label>
  93.                 <url>mk:@MSITStore:msqry32.chm::/html/qutbcMicrosoftTextDriver.htm</url>
  94.             </topic>
  95.             <topic>
  96.                 <label>Set up a data source that uses the Microsoft SQL Server driver</label>
  97.                 <url>mk:@MSITStore:msqry32.chm::/html/qutbcSQLServerDriver.htm</url>
  98.             </topic>
  99.         </book>
  100.         <book>
  101.             <label>Creating, Opening, and Saving Queries</label>
  102.             <topic>
  103.                 <label>About creating a new query</label>
  104.                 <url>mk:@MSITStore:msqry32.chm::/html/quconGuidelinesForConstructingQuery.htm</url>
  105.             </topic>
  106.             <topic>
  107.                 <label>Create a new query</label>
  108.                 <url>mk:@MSITStore:msqry32.chm::/html/qutbcCreateNewQuery.htm</url>
  109.             </topic>
  110.             <topic>
  111.                 <label>Create a parameter query</label>
  112.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowCreateParameterQuery.htm</url>
  113.             </topic>
  114.             <topic>
  115.                 <label>Open a query</label>
  116.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowOpenQuery.htm</url>
  117.             </topic>
  118.             <topic>
  119.                 <label>Save a query</label>
  120.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowSaveQueryFileForReuse.htm</url>
  121.             </topic>
  122.             <topic>
  123.                 <label>Run, view, or edit an SQL command, procedure, or statement</label>
  124.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowViewOrEditSQLSELECTStatementForQuery.htm</url>
  125.             </topic>
  126.         </book>
  127.         <book>
  128.             <label>Running Queries</label>
  129.             <topic>
  130.                 <label>Run a query automatically, or wait to run the query at a later time</label>
  131.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowRunQueryAutomaticallyOrWaitToRunAtLaterTime.htm</url>
  132.             </topic>
  133.             <topic>
  134.                 <label>Return a result set to Microsoft Excel</label>
  135.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowReturnResultSetToMicrosoftExcel.htm</url>
  136.             </topic>
  137.             <topic>
  138.                 <label>Execute an SQL statement or procedure</label>
  139.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowExecuteSQLStatement.htm</url>
  140.             </topic>
  141.         </book>
  142.         <book>
  143.             <label>Creating and Connecting to OLAP Cubes</label>
  144.             <topic>
  145.                 <label>About OLAP queries</label>
  146.                 <url>mk:@MSITStore:msqry32.chm::/html/quconOLAPQueries.htm</url>
  147.             </topic>
  148.             <topic>
  149.                 <label>About creating an OLAP cube from relational data</label>
  150.                 <url>mk:@MSITStore:msqry32.chm::/html/quconAboutCreatingOLAPCubeForQueriedData.htm</url>
  151.             </topic>
  152.             <topic>
  153.                 <label>Create an OLAP cube from relational data</label>
  154.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowCreateOLAPCube.htm</url>
  155.             </topic>
  156.             <topic>
  157.                 <label>Change content and settings of an OLAP cube</label>
  158.                 <url>mk:@MSITStore:msqry32.chm::/html/qudecChangeCube.htm</url>
  159.             </topic>
  160.             <topic>
  161.                 <label>Delete an offline cube file</label>
  162.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowDeleteCube.htm</url>
  163.             </topic>
  164.         </book>
  165.         <book>
  166.             <label>Changing Queries</label>
  167.             <book>
  168.                 <label>Adding and Removing Tables and Files</label>
  169.                 <topic>
  170.                     <label>Add a table to a query</label>
  171.                     <url>mk:@MSITStore:msqry32.chm::/html/quhowAddOrRemoveTablesInQuery.htm</url>
  172.                 </topic>
  173.                 <topic>
  174.                     <label>Delete a table from a query</label>
  175.                     <url>mk:@MSITStore:msqry32.chm::/html/quconDeleteTableFromQuery.htm</url>
  176.                 </topic>
  177.                 <topic>
  178.                     <label>Add or remove a field</label>
  179.                     <url>mk:@MSITStore:msqry32.chm::/html/quhowAddFieldToQuery.htm</url>
  180.                 </topic>
  181.                 <topic>
  182.                     <label>Run, view, or edit an SQL command, procedure, or statement</label>
  183.                     <url>mk:@MSITStore:msqry32.chm::/html/quhowViewOrEditSQLSELECTStatementForQuery.htm</url>
  184.                 </topic>
  185.             </book>
  186.             <book>
  187.                 <label>Creating, Changing, and Removing Joins</label>
  188.                 <topic>
  189.                     <label>Retrieve related records from multiple tables with joins</label>
  190.                     <url>mk:@MSITStore:msqry32.chm::/html/quhowRetrieveRecordsThumb.htm</url>
  191.                 </topic>
  192.                 <topic>
  193.                     <label>Retrieve records from multiple tables</label>
  194.                     <url>mk:@MSITStore:msqry32.chm::/html/qudecJoinTablesInQuery.htm</url>
  195.                 </topic>
  196.                 <topic>
  197.                     <label>Combine all the data from two tables</label>
  198.                     <url>mk:@MSITStore:msqry32.chm::/html/qutbcQueryWontLetMeCombineDataFromTwoMicrosoftExcelLists.htm</url>
  199.                 </topic>
  200.                 <topic>
  201.                     <label>Retrieve records that two tables don't have in common</label>
  202.                     <url>mk:@MSITStore:msqry32.chm::/html/qutbcIWantToSeeRecordsThatTwoTablesDontHaveInCommon.htm</url>
  203.                 </topic>
  204.                 <topic>
  205.                     <label>Create an outer join</label>
  206.                     <url>mk:@MSITStore:msqry32.chm::/html/quhowCreateOuterJoin.htm</url>
  207.                 </topic>
  208.                 <topic>
  209.                     <label>Create a self-join</label>
  210.                     <url>mk:@MSITStore:msqry32.chm::/html/quhowCreateSelfJoin.htm</url>
  211.                 </topic>
  212.                 <topic>
  213.                     <label>Operators in joins</label>
  214.                     <url>mk:@MSITStore:msqry32.chm::/html/qurefHowOperatorsAffectJoin.htm</url>
  215.                 </topic>
  216.                 <topic>
  217.                     <label>Remove a join</label>
  218.                     <url>mk:@MSITStore:msqry32.chm::/html/quhowRemoveJoin.htm</url>
  219.                 </topic>
  220.             </book>
  221.         </book>
  222.         <book>
  223.             <label>Limiting the Data You Retrieve</label>
  224.             <topic>
  225.                 <label>About using criteria</label>
  226.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowThumbAboutCriteria.htm</url>
  227.             </topic>
  228.             <topic>
  229.                 <label>Limit the records you retrieve by using criteria</label>
  230.                 <url>mk:@MSITStore:msqry32.chm::/html/qudecUseCriteriaToRetrieveSpecificRecords.htm</url>
  231.             </topic>
  232.             <topic>
  233.                 <label>Specify what records to retrieve by using criteria</label>
  234.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowSpecifyCriteriaToRetrieveRecords.htm</url>
  235.             </topic>
  236.             <topic>
  237.                 <label>Retrieve records that match a specific value</label>
  238.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowRetrieveRecordsThatMatchValue.htm</url>
  239.             </topic>
  240.             <topic>
  241.                 <label>Examples of expressions</label>
  242.                 <url>mk:@MSITStore:msqry32.chm::/html/qurefExpressionsYouCanUseToCreateCustomQueries.htm</url>
  243.             </topic>
  244.             <topic>
  245.                 <label>Restore the full result set by removing criteria</label>
  246.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowRestoreFullResultSetByRemovingCriteria.htm</url>
  247.             </topic>
  248.         </book>
  249.         <book>
  250.             <label>Creating Calculated Fields</label>
  251.             <topic>
  252.                 <label>Create a calculated field</label>
  253.                 <url>mk:@MSITStore:msqry32.chm::/html/qudecCalculateFieldsUsingExpressionsOrFunctions.htm</url>
  254.             </topic>
  255.             <topic>
  256.                 <label>Create a calculated field by using an expression</label>
  257.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowAddCalculatedDatabaseFieldToQuery.htm</url>
  258.             </topic>
  259.             <topic>
  260.                 <label>Create a calculated field by using a function</label>
  261.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowCalculateTotalsInQuery.htm</url>
  262.             </topic>
  263.             <topic>
  264.                 <label>Functions you can use in a calculated field</label>
  265.                 <url>mk:@MSITStore:msqry32.chm::/html/qurefSummaryFunctionsForTotalsInQueries.htm</url>
  266.             </topic>
  267.         </book>
  268.         <book>
  269.             <label>Changing the Result Set</label>
  270.             <topic>
  271.                 <label>Change the layout of a result set</label>
  272.                 <url>mk:@MSITStore:msqry32.chm::/html/qudecFormatDataInQuery.htm</url>
  273.             </topic>
  274.             <topic>
  275.                 <label>Format data in Microsoft Query</label>
  276.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowChangeHowYouViewDataInMicrosoftQuery.htm</url>
  277.             </topic>
  278.         </book>
  279.         <book>
  280.             <label>Finding, Sorting, and Viewing Data</label>
  281.             <topic>
  282.                 <label>Go to a specific record in the result set</label>
  283.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowGoToSpecificRecordInResultSet.htm</url>
  284.             </topic>
  285.             <topic>
  286.                 <label>Sort records in a query</label>
  287.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowSortRecordsInQuery.htm</url>
  288.             </topic>
  289.             <topic>
  290.                 <label>View different fields in a query</label>
  291.                 <url>mk:@MSITStore:msqry32.chm::/html/quhowViewDifferentRecordsInQuery.htm</url>
  292.             </topic>
  293.         </book>
  294.         <book>
  295.             <label>Changing Data in a Queried Database</label>
  296.             <topic>
  297.                 <label>About making changes to data in a queried database</label>
  298.                 <url>mk:@MSITStore:msqry32.chm::/html/quconAboutMakingChangesToDataInQueriedDatabase.htm</url>
  299.             </topic>
  300.             <topic>
  301.                 <label>Make changes to data in a queried database</label>
  302.                 <url>mk:@MSITStore:msqry32.chm::/html/qudecMakeChangesToDataInQueriedDatabase.htm</url>
  303.             </topic>
  304.         </book>
  305.         <book>
  306.             <label>Using Dynamic Data Exchange (DDE)</label>
  307.             <topic>
  308.                 <label>Use Dynamic Data Exchange (DDE) with Microsoft Query</label>
  309.                 <url>mk:@MSITStore:msqry32.chm::/html/DDEUsingDynamicDataExchangewithMicrosoftQuery.htm</url>
  310.             </topic>
  311.             <topic>
  312.                 <label>DDE commands</label>
  313.                 <url>mk:@MSITStore:msqry32.chm::/html/qurefDDECommands.htm</url>
  314.             </topic>
  315.         </book>
  316.         <book>
  317.             <label>Troubleshooting</label>
  318.             <topic>
  319.                 <label>Troubleshoot Microsoft Query</label>
  320.                 <url>mk:@MSITStore:msqry32.chm::/html/qutbsTroubleshootUsingMicrosoftQuery.htm</url>
  321.             </topic>
  322.             <topic>
  323.                 <label>Troubleshoot OLAP queries and cubes</label>
  324.                 <url>mk:@MSITStore:msqry32.chm::/html/qutbsTshootOLAP.htm</url>
  325.             </topic>
  326.         </book>
  327.         <book>
  328.             <label>Y2K</label>
  329.             <topic>
  330.                 <label>How Microsoft Query handles year 2000 dates</label>
  331.                 <url>mk:@MSITStore:msqry32.chm::/html/quconQueryY2K.htm</url>
  332.             </topic>
  333.         </book>
  334.     </book>
  335. </toc>